CREATE TABLE [dbo].[Tb_Sms_Filtre](
	[Ad] [nvarchar](20) NULL,
	[Saha] [nvarchar](50) NULL,
	[Ilk] [nvarchar](50) NULL,
	[Son] [nvarchar](50) NULL,
	[FiltreEH] [smallint] NULL,
	[Mesaj_Referans] [decimal](18, 0) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Sms_Liste](
	[LstId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[Kod] [nvarchar](20) NULL,
	[Unvan] [nvarchar](100) NULL,
	[Ad] [nvarchar](30) NULL,
	[Soyad] [nvarchar](50) NULL,
	[Telefon] [nvarchar](20) NULL,
	[Semt] [nvarchar](20) NULL,
	[CariId] [decimal](18, 0) NULL,
	[Tip] [tinyint] NULL,
	[ListeId] [decimal](18, 0) NULL,
	[DonenId] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Sms_Liste] PRIMARY KEY CLUSTERED 
(
	[LstId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Sms_MesajTanim](
	[Referans] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[MesajAdi] [nvarchar](50) NULL,
	[Mesaj] [nvarchar](500) NULL,
	[Tip] [tinyint] NULL CONSTRAINT [DF_Tb_Sms_MesajTanim_Tip]  DEFAULT ((0)),
 CONSTRAINT [PK_Tb_Sms_MesajTanim] PRIMARY KEY CLUSTERED 
(
	[Referans] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Sms_Rapor](
	[RaporId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[Tarih] [smalldatetime] NULL,
	[Mesaj] [nvarchar](500) NULL,
	[KisiSayisi] [int] NULL,
	[Gonderim] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Sms_Rapor] PRIMARY KEY CLUSTERED 
(
	[RaporId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO